Transformations
Introduction
GigaSpaces Data Integration feature will now include transformations. Configuring transformations enables data to be converted into a simple format that can then be used for the easy creation of services.
Acting as a conduit for data, data pipelines enable efficient processing, transformation, and delivery of data to the desired location.
Through data cleansing and transformation processes, data pipelines enhance data quality and ensure accuracy for analysis and decision-making.
Implementation
Low-code transformation can be created and updated through our SpaceDeck UI. Refer to the SpaceDeck – Configuring Transformations page for more details.
Phase 1 Transformations
Initially, GigaSpaces will be offering the transformations listed below. The scope will be increased in future versions.
-
Calculated column - Adding a column, calculation of VAT, mathematical operations, string operations, date operations, etc.
-
FILTER (aka WHERE) clause
-
Calling external REST API
function - Calculation of insurance risk based on captured transaction record
Even though there is no limit to the number of transformations that can be configured, using an excessive amount could affect performance.
Apache Flink SQL Function Support
GigaSpaces supports the following Flink SQL built-in functions for data transformations:
User Flow
The flow below, assumes the user has already created a Space and assigned a Data Source.